Hi,
you can automate your process using a command prompt utility named
"bcp"; if you try to execute this command you get the syntax:
C:\>bcp
usage: bcp {dbtable | query} {in | out | queryout | format} datafile
[-m maxerrors] [-f formatfile] [-e errfile]
[-F firstrow] [-L lastrow] [-b batchsize]
[-n native type] [-c character type] [-w wide
character type]
[-N keep non-text native] [-V file format version] [-q quoted
identifier]
[-C code page specifier] [-t field terminator] [-r row
terminator]
[-i inputfile] [-o outfile] [-a packetsize]
[-S server name] [-U username] [-P password]
[-T trusted connection] [-v version] [-R regional
enable]
[-k keep null values] [-E keep identity values]
[-h "load hints"]
Another way is to use the T-SQL command "BULK INSERT".
You can find explanations on your MS-SQL documentation.
Bye.
mo****@datashark.net (Monica J. Braverman) wrote in message news:<d7**************************@posting.google. com>...
My client will be receiving a .dbf file which needs to be uploaded
into a sql server database table (as an append) every week. They are
NOT computer savvy and I would like to automate this process rather
than go into enterprise manager and run data transformation.
Is there any way to write a batch file or a set of command lines which
will do this?
Thanks.
Monica